=================================================================================


Dataset

                               waste_type total_waste_generated_tonne
1               Construction & Demolition                     1624000
2                          Ferrous Metals                     1269000
3                         Paper/Cardboard                     1054000
4                                Plastics                      949000
5                                    Food                      763000
6                             Wood/Timber                      521000
7                           Horticultural                      320000
8                         Textile/Leather                      220000
9                               Used Slag                      181000
10                     Non-Ferrous Metals                      171000
11                                  Glass                       64000
12                            Scrap Tyres                       32000
13  Others (stones, ceramic, rubber, ect)                      286000
14                                Overall                     7695000
15              Construction & Demolition                     1440000
16                         Ferrous Metals                     1278000
17                        Paper/Cardboard                     1011000
18                               Plastics                      930000
19                                   Food                      744000
20                            Wood/Timber                      438000
21                          Horticultural                      400000
22                        Textile/Leather                      168000
23                              Used Slag                      129000
24                     Non-Ferrous Metals                      126000
25                                  Glass                       75000
26                            Scrap Tyres                       33000
27  Others (stones, ceramic, rubber, ect)                      210000
28                                Overall                     7234000
29                        Paper/Cardboard                     1144000
30                         Ferrous Metals                      934000
31                               Plastics                      868000
32              Construction & Demolition                      825000
33                                   Food                      665000
34                          Horticultural                      313000
35                            Wood/Timber                      304000
36                        Textile/Leather                      137000
37                              Used slag                      106000
38                     Non-Ferrous Metals                       75000
39                                  Glass                       66000
40                            Scrap Tyres                       23000
41  Others (stones, ceramic, rubber, ect)                      193000
42                                Overall                     5880000
43              Construction & Demolition                     1013000
44                         Ferrous Metals                     1312000
45                        Paper/Cardboard                     1136000
46                               Plastics                      982000
47                                   Food                      817000
48                            Wood/Timber                      310000
49                          Horticultural                      332000
50                        Textile/Leather                      189000
51                              Used Slag                      182000
52                     Non-Ferrous Metals                       88000
53                                  Glass                       74000
54                            Scrap Tyres                       27000
55  Others (stones, ceramic, rubber, ect)                      233000
56                                Overall                     6944000
57              Construction & Demolition                     1424000
58                         Ferrous Metals                     1338000
59                        Paper/Cardboard                     1064000
60                               Plastics                     1001000
61                                   Food                      813000
62                            Wood/Timber                      419000
63                          Horticultural                      221000
64                        Textile/Leather                      254000
65                              Used Slag                      169000
66                     Non-Ferrous Metals                       92000
67                                  Glass                       73000
68                            Scrap Tyres                       26000
69  Others (stones, ceramic, rubber, ect)                      249000
70                                Overall                     7385000
71                                   Food                      791000
72                        Paper/Cardboard                     1183000
73                               Plastics                      822000
74              Construction & Demolition                     1595000
75                          Horticultural                      321000
76                            Wood/Timber                      531000
77                         Ferrous Metals                     1358000
78                     Non-Ferrous Metals                       97000
79                              Used slag                      251000
80                                  Glass                       72000
81                        Textile/Leather                      151000
82                            Scrap Tyres                       33000
83  Others (stones, ceramic, rubber, ect)                      383000
84                                Overall                     7814000
85                                   Food                      786000
86                        Paper/Cardboard                     1192000
87                               Plastics                      825000
88              Construction & Demolition                     1412000
89                          Horticultural                      362000
90                            Wood/Timber                      371000
91                         Ferrous Metals                     1349000
92                     Non-Ferrous Metals                      180000
93                              Used slag                      370000
94                                  Glass                       75000
95                        Textile/Leather                      157000
96                            Scrap Tyres                       36000
97  Others (stones, ceramic, rubber, ect)                      365000
98                                Overall                     7674000
99                                   Food                      789000
100                       Paper/Cardboard                     1237000
101                              Plastics                      869000
102             Construction & Demolition                     1270000
103                         Horticultural                      278000
104                           Wood/Timber                      368000
105                        Ferrous Metals                     1446000
106                    Non-Ferrous Metals                      118000
107                             Used slag                      366000
108                                 Glass                       80000
109                       Textile/Leather                      159000
110                           Scrap Tyres                       26000
111 Others (stones, ceramic, rubber, ect)                      360000
112                               Overall                     7515000
113                                  Food                      796000
114                       Paper/Cardboard                     1261000
115                              Plastics                      832000
116             Construction & Demolition                     1695000
117                           Wood/Timber                      332000
118                         Horticultural                      253000
119                        Ferrous Metals                     1416000
120                    Non-Ferrous Metals                      135000
121                             Used Slag                      354000
122                                 Glass                       74000
123                       Textile/Leather                      157000
124                           Scrap Tyres                       22000
125 Others (stones, ceramic, rubber, ect)                      335000
126                               Overall                     7852000
127                                  Food                      703000
128                       Paper/Cardboard                     1252000
129                              Plastics                      803000
130             Construction & Demolition                     1292000
131                           Wood/Timber                      344000
132                         Horticultural                      248000
133                        Ferrous Metals                     1386000
134                    Non-Ferrous Metals                      123000
135                             Used Slag                      368000
136                                 Glass                       75000
137                       Textile/Leather                      159000
138                           Scrap Tyres                       18000
139 Others (stones, ceramic, rubber, ect)                      338000
140                               Overall                     7270000
141                                  Food                      676000
142                       Paper/Cardboard                     1368000
143                              Plastics                      733000
144             Construction & Demolition                     1204000
145                           Wood/Timber                      274000
146                         Horticultural                      239000
147                        Ferrous Metals                     1239000
148                    Non-Ferrous Metals                      117000
149                             Used Slag                      342000
150                                 Glass                       73000
151                       Textile/Leather                      131000
152                           Scrap Tyres                       22000
153 Others (stones, ceramic, rubber, ect)                      328000
154                               Overall                     6898000
155                                  Food                      641000
156                       Paper/Cardboard                     1384000
157                              Plastics                      740000
158             Construction & Demolition                      922000
159                           Wood/Timber                      270000
160                         Horticultural                      251000
161                        Ferrous Metals                     1195000
162                    Non-Ferrous Metals                       86000
163                             Used Slag                      383000
164                                 Glass                       80000
165                       Textile/Leather                      121000
166                           Scrap Tyres                       24000
167 Others (stones, ceramic, rubber, ect)                      307000
168                               Overall                     6517000
169                                  Food                      606000
170                       Paper/Cardboard                     1201000
171                              Plastics                      689000
172             Construction & Demolition                     1176000
173                           Wood/Timber                      288000
174                         Horticultural                      238000
175                        Ferrous Metals                      872000
176                    Non-Ferrous Metals                       58000
177                             Used Slag                      422000
178                                 Glass                       73000
179                       Textile/Leather                      109000
180                           Scrap Tyres                       23000
181 Others (stones, ceramic, rubber, ect)                      271000
182                               Overall                     6114000
183                                  Food                      568000
184                       Paper/Cardboard                     1263000
185                              Plastics                      684000
186             Construction & Demolition                      922000
187                           Wood/Timber                      270000
188                         Horticultural                      229000
189                        Ferrous Metals                      785000
190                    Non-Ferrous Metals                       85000
191                             Used Slag                      566000
192                                 Glass                       57000
193                       Textile/Leather                       93000
194                           Scrap Tyres                       25000
195 Others (stones, ceramic, rubber, ect)                      308000
196                               Overall                     5970000
197                                  Food                      559000
198                       Paper/Cardboard                     1203000
199                              Plastics                      660000
200             Construction & Demolition                      778000
201                           Wood/Timber                      246000
202                         Horticultural                      225000
203                        Ferrous Metals                      737000
204                    Non-Ferrous Metals                       92000
205                             Used Slag                      527000
206                                 Glass                       65000
207                       Textile/Leather                      110000
208                           Scrap Tyres                       26000
209 Others (stones, ceramic, rubber, ect)                      249000
210                               Overall                     5601000
211                                  Food                      543000
212                       Paper/Cardboard                     1116000
213                              Plastics                      657000
214             Construction & Demolition                      619000
215                           Wood/Timber                      224000
216                         Horticultural                      231000
217                        Ferrous Metals                      726000
218                    Non-Ferrous Metals                       87000
219                             Used Slag                      471000
220                                 Glass                       63000
221                       Textile/Leather                       92000
222                           Scrap Tyres                       24000
223 Others (stones, ceramic, rubber, ect)                      242000
224                               Overall                     5221000
225                                  Food                      532000
226                       Paper/Cardboard                     1099000
227                              Plastics                      675000
228             Construction & Demolition                      493000
229                           Wood/Timber                      239000
230                         Horticultural                      200000
231                        Ferrous Metals                      818000
232                    Non-Ferrous Metals                       89000
233                             Used Slag                      382000
234                                 Glass                       63000
235                       Textile/Leather                       89000
236                           Scrap Tyres                       17000
237 Others (stones, ceramic, rubber, ect)                      225000
238                               Overall                     5018000
239                                  Food                      531000
240                       Paper/Cardboard                     1132000
241                              Plastics                      683000
242             Construction & Demolition                      509000
243                           Wood/Timber                      222000
244                         Horticultural                      227000
245                        Ferrous Metals                      720000
246                    Non-Ferrous Metals                       87000
247                             Used Slag                      267000
248                                 Glass                       74000
249                       Textile/Leather                      115000
250                           Scrap Tyres                       15000
251 Others (stones, ceramic, rubber, ect)                      114000
252                               Overall                     4790000
253                                  Food                      548000
254                       Paper/Cardboard                     1085000
255                              Plastics                      580000
256             Construction & Demolition                      423000
257                           Wood/Timber                      213000
258                         Horticultural                      305000
259                        Ferrous Metals                      857000
260                    Non-Ferrous Metals                       94000
261                             Used Slag                      260000
262                                 Glass                       66000
263                       Textile/Leather                       92000
264                           Scrap Tyres                       14000
265 Others (stones, ceramic, rubber, ect)                      104000
266                               Overall                     4728000
267             Construction & Demolition                     1609000
268                        Ferrous Metals                     1379000
269                             Used slag                      273000
270                    Non-Ferrous Metals                       94000
271                           Scrap Tyres                       36000
272                           Wood/Timber                      424000
273                         Horticultural                      328000
274                       Paper/Cardboard                     1145000
275                                 Glass                       71000
276                                  Food                      810000
277                              Plastics                      815000
278                       Textile/Leather                      151000
279 Others (stones, ceramic, rubber, ect)                      326000
280                               Overall                     7704000
    total_waste_recycled_tonne year total_waste_not_recycled_tonne
1                      1618000 2018                              6
2                       126000 2018                           1143
3                       586000 2018                            468
4                        41000 2018                            908
5                       126000 2018                            637
6                       428000 2018                             93
7                       227000 2018                             93
8                        14000 2018                            206
9                       179000 2018                              2
10                      170000 2018                              1
11                       12000 2018                             52
12                       29000 2018                              3
13                       11000 2018                            275
14                     4726000 2018                           2969
15                     1434000 2019                              6
16                     1270000 2019                              8
17                      449000 2019                            562
18                       37000 2019                            893
19                      136000 2019                            608
20                      289000 2019                            149
21                      293000 2019                            107
22                        6000 2019                            162
23                      127000 2019                              2
24                      124000 2019                              2
25                       11000 2019                             64
26                       31000 2019                              2
27                       15000 2019                            195
28                     4247000 2019                           2987
29                      432000 2020                            712
30                      930000 2020                              4
31                       36000 2020                            832
32                      822000 2020                              3
33                      126000 2020                            539
34                      249000 2020                             64
35                      195000 2020                            109
36                        6000 2020                            131
37                      104000 2020                              2
38                       73000 2020                              2
39                        7000 2020                             59
40                       22000 2020                              1
41                       21000 2020                            172
42                     3040000 2020                           2840
43                     1011000 2021                              2
44                     1306000 2021                              6
45                      437000 2021                            699
46                       58000 2021                            924
47                      154000 2021                            663
48                      234000 2021                             76
49                      277000 2021                             55
50                        7000 2021                            182
51                      181000 2021                              1
52                       87000 2021                              1
53                        9000 2021                             65
54                       26000 2021                              1
55                       18000 2021                            215
56                     3826000 2021                           3118
57                     1419000 2022                              5
58                     1331000 2022                              7
59                      394000 2022                            670
60                       57000 2022                            944
61                      146000 2022                            667
62                      298000 2022                            121
63                      188000 2022                             33
64                        5000 2022                            249
65                      166000 2022                              3
66                       91000 2022                              1
67                       11000 2022                             62
68                       25000 2022                              1
69                       30000 2022                            219
70                     4188000 2022                           3197
71                      111000 2016                            680
72                      607000 2016                            576
73                       60000 2016                            762
74                     1586000 2016                              9
75                      209000 2016                            112
76                      412000 2016                            119
77                     1352000 2016                              6
78                       96000 2016                              1
79                      247000 2016                              4
80                       15000 2016                             57
81                       11000 2016                            140
82                       30000 2016                              3
83                        7000 2016                            376
84                     4769000 2016                           3045
85                      104000 2015                            682
86                      604000 2015                            588
87                       58000 2015                            767
88                     1403000 2015                              9
89                      237000 2015                            125
90                      294000 2015                             77
91                     1333000 2015                             16
92                      160000 2015                             20
93                      366000 2015                              4
94                       15000 2015                             60
95                       13000 2015                            144
96                       33000 2015                              3
97                        6000 2015                            359
98                     4650000 2015                           3024
99                      101000 2014                            688
100                     647000 2014                            590
101                      80000 2014                            789
102                    1260000 2014                             10
103                     163000 2014                            115
104                     293000 2014                             75
105                    1389000 2014                             57
106                      95000 2014                             23
107                     361000 2014                              5
108                      16000 2014                             64
109                      17000 2014                            142
110                      23000 2014                              3
111                       5000 2014                            355
112                    4471000 2014                           3044
113                     100000 2013                            696
114                     679000 2013                            582
115                      91000 2013                            741
116                    1683000 2013                             12
117                     255000 2013                             77
118                     121000 2013                            132
119                    1369000 2013                             47
120                     114000 2013                             21
121                     345000 2013                              9
122                      15000 2013                             59
123                      16000 2013                            141
124                      19000 2013                              3
125                       5000 2013                            330
126                    4826000 2013                           3026
127                      85000 2012                            618
128                     697000 2012                            555
129                      82000 2012                            721
130                    1283000 2012                              9
131                     236000 2012                            108
132                     108000 2012                            140
133                    1331000 2012                             55
134                      97000 2012                             26
135                     358000 2012                             10
136                      20000 2012                             55
137                      18000 2012                            141
138                      16000 2012                              2
139                       5000 2012                            333
140                    4336000 2012                           2934
141                      70000 2011                            606
142                     765000 2011                            603
143                      77000 2011                            656
144                    1191000 2011                             13
145                     177000 2011                             97
146                      89000 2011                            150
147                    1172000 2011                             67
148                     103000 2011                             14
149                     336000 2011                              6
150                      21000 2011                             52
151                      17000 2011                            114
152                      18000 2011                              4
153                       3000 2011                            325
154                    4039000 2011                           2859
155                     102000 2010                            539
156                     738000 2010                            646
157                      78000 2010                            662
158                     912000 2010                             10
159                     190000 2010                             80
160                      99000 2010                            152
161                    1128000 2010                             67
162                      73000 2010                             13
163                     379000 2010                              4
164                      19000 2010                             61
165                      15000 2010                            106
166                      20000 2010                              4
167                       4000 2010                            303
168                    3758000 2010                           2759
169                      77000 2009                            529
170                     574000 2009                            627
171                      60000 2009                            629
172                    1151000 2009                             25
173                     207000 2009                             81
174                      94000 2009                            144
175                     806000 2009                             66
176                      48000 2009                             10
177                     419000 2009                              3
178                      16000 2009                             57
179                      13000 2009                             96
180                      19000 2009                              4
181                       3000 2009                            268
182                    3485000 2009                           2629
183                      68000 2008                            500
184                     609000 2008                            654
185                      61000 2008                            623
186                     900000 2008                             22
187                     190000 2008                             80
188                      96000 2008                            133
189                     735000 2008                             50
190                      72000 2008                             13
191                     561000 2008                              5
192                      10000 2008                             47
193                      11000 2008                             82
194                      22000 2008                              3
195                       8000 2008                            300
196                    3343000 2008                           2627
197                      51000 2007                            508
198                     619000 2007                            584
199                      75000 2007                            585
200                     759000 2007                             19
201                     128000 2007                            118
202                      91000 2007                            134
203                     668000 2007                             69
204                      76000 2007                             16
205                     520000 2007                              7
206                       6000 2007                             59
207                       6000 2007                            104
208                      22000 2007                              4
209                      14000 2007                            235
210                    3035000 2007                           2566
211                      45000 2006                            498
212                     571000 2006                            545
213                      78000 2006                            579
214                     604000 2006                             15
215                      82000 2006                            142
216                      87000 2006                            144
217                     657000 2006                             69
218                      71000 2006                             16
219                     417000 2006                             54
220                       6000 2006                             57
221                       4000 2006                             88
222                      19000 2006                              5
223                      15000 2006                            227
224                    2657000 2006                           2564
225                      37000 2005                            495
226                     541000 2005                            558
227                      86000 2005                            589
228                     465000 2005                             28
229                      90000 2005                            149
230                     101000 2005                             99
231                     749000 2005                             69
232                      75000 2005                             14
233                     299000 2005                             83
234                       4000 2005                             59
235                       4000 2005                             85
236                      11000 2005                              6
237                       9000 2005                            216
238                    2469000 2005                           2549
239                      31000 2004                            500
240                     520000 2004                            612
241                      74000 2004                            609
242                     471000 2004                             38
243                      74000 2004                            148
244                     128000 2004                             99
245                     650000 2004                             70
246                      72000 2004                             15
247                     260000 2004                              7
248                       5000 2004                             69
249                       5000 2004                            110
250                       7000 2004                              8
251                      11000 2004                            103
252                    2307000 2004                           2483
253                      33000 2003                            515
254                     466000 2003                            619
255                      39000 2003                            541
256                     398000 2003                             25
257                      41000 2003                            172
258                     119000 2003                            186
259                     799000 2003                             58
260                      76000 2003                             18
261                     239000 2003                             21
262                       6000 2003                             60
263                       1000 2003                             91
264                       6000 2003                              8
265                          0 2003                            104
266                    2223000 2003                           2505
267                    1600000 2017                              9
268                    1371000 2017                              8
269                     269000 2017                              4
270                      92000 2017                              2
271                      33000 2017                              3
272                     327000 2017                             97
273                     221000 2017                            107
274                     569000 2017                            576
275                      12000 2017                             59
276                     133000 2017                            677
277                      52000 2017                            763
278                      10000 2017                            141
279                       7000 2017                            319
280                    4724000 2017                           2980
    recycling_rate wasting_rate
1             1.00         0.00
2             0.10         0.90
3             0.56         0.44
4             0.04         0.96
5             0.17         0.83
6             0.82         0.18
7             0.71         0.29
8             0.06         0.94
9             0.99         0.01
10            0.99         0.01
11            0.19         0.81
12            0.91         0.09
13            0.04         0.96
14            0.61         0.39
15            1.00         0.00
16            0.99         0.01
17            0.44         0.56
18            0.04         0.96
19            0.18         0.82
20            0.66         0.34
21            0.73         0.27
22            0.04         0.96
23            0.98         0.02
24            0.98         0.02
25            0.15         0.85
26            0.94         0.06
27            0.07         0.93
28            0.59         0.41
29            0.38         0.62
30            1.00         0.00
31            0.04         0.96
32            1.00         0.00
33            0.19         0.81
34            0.80         0.20
35            0.64         0.36
36            0.04         0.96
37            0.98         0.02
38            0.97         0.03
39            0.11         0.89
40            0.96         0.04
41            0.11         0.89
42            0.52         0.48
43            1.00         0.00
44            1.00         0.00
45            0.38         0.62
46            0.06         0.94
47            0.19         0.81
48            0.75         0.25
49            0.83         0.17
50            0.04         0.96
51            0.99         0.01
52            0.99         0.01
53            0.12         0.88
54            0.96         0.04
55            0.08         0.92
56            0.55         0.45
57            1.00         0.00
58            0.99         0.01
59            0.37         0.63
60            0.06         0.94
61            0.18         0.82
62            0.71         0.29
63            0.85         0.15
64            0.02         0.98
65            0.98         0.02
66            0.99         0.01
67            0.15         0.85
68            0.96         0.04
69            0.12         0.88
70            0.57         0.43
71            0.14         0.86
72            0.51         0.49
73            0.07         0.93
74            0.99         0.01
75            0.65         0.35
76            0.78         0.22
77            1.00         0.00
78            0.99         0.01
79            0.98         0.02
80            0.21         0.79
81            0.07         0.93
82            0.91         0.09
83            0.02         0.98
84            0.61         0.39
85            0.13         0.87
86            0.51         0.49
87            0.07         0.93
88            0.99         0.01
89            0.65         0.35
90            0.79         0.21
91            0.99         0.01
92            0.89         0.11
93            0.99         0.01
94            0.20         0.80
95            0.08         0.92
96            0.92         0.08
97            0.02         0.98
98            0.61         0.39
99            0.13         0.87
100           0.52         0.48
101           0.09         0.91
102           0.99         0.01
103           0.59         0.41
104           0.80         0.20
105           0.96         0.04
106           0.81         0.19
107           0.99         0.01
108           0.20         0.80
109           0.11         0.89
110           0.88         0.12
111           0.01         0.99
112           0.59         0.41
113           0.13         0.87
114           0.54         0.46
115           0.11         0.89
116           0.99         0.01
117           0.77         0.23
118           0.48         0.52
119           0.97         0.03
120           0.84         0.16
121           0.97         0.03
122           0.20         0.80
123           0.10         0.90
124           0.86         0.14
125           0.01         0.99
126           0.61         0.39
127           0.12         0.88
128           0.56         0.44
129           0.10         0.90
130           0.99         0.01
131           0.69         0.31
132           0.44         0.56
133           0.96         0.04
134           0.79         0.21
135           0.97         0.03
136           0.27         0.73
137           0.11         0.89
138           0.89         0.11
139           0.01         0.99
140           0.60         0.40
141           0.10         0.90
142           0.56         0.44
143           0.11         0.89
144           0.99         0.01
145           0.65         0.35
146           0.37         0.63
147           0.95         0.05
148           0.88         0.12
149           0.98         0.02
150           0.29         0.71
151           0.13         0.87
152           0.82         0.18
153           0.01         0.99
154           0.59         0.41
155           0.16         0.84
156           0.53         0.47
157           0.11         0.89
158           0.99         0.01
159           0.70         0.30
160           0.39         0.61
161           0.94         0.06
162           0.85         0.15
163           0.99         0.01
164           0.24         0.76
165           0.12         0.88
166           0.83         0.17
167           0.01         0.99
168           0.58         0.42
169           0.13         0.87
170           0.48         0.52
171           0.09         0.91
172           0.98         0.02
173           0.72         0.28
174           0.39         0.61
175           0.92         0.08
176           0.83         0.17
177           0.99         0.01
178           0.22         0.78
179           0.12         0.88
180           0.83         0.17
181           0.01         0.99
182           0.57         0.43
183           0.12         0.88
184           0.48         0.52
185           0.09         0.91
186           0.98         0.02
187           0.70         0.30
188           0.42         0.58
189           0.94         0.06
190           0.85         0.15
191           0.99         0.01
192           0.18         0.82
193           0.12         0.88
194           0.88         0.12
195           0.03         0.97
196           0.56         0.44
197           0.09         0.91
198           0.51         0.49
199           0.11         0.89
200           0.98         0.02
201           0.52         0.48
202           0.40         0.60
203           0.91         0.09
204           0.83         0.17
205           0.99         0.01
206           0.09         0.91
207           0.05         0.95
208           0.85         0.15
209           0.06         0.94
210           0.54         0.46
211           0.08         0.92
212           0.51         0.49
213           0.12         0.88
214           0.98         0.02
215           0.37         0.63
216           0.38         0.62
217           0.90         0.10
218           0.82         0.18
219           0.89         0.11
220           0.10         0.90
221           0.04         0.96
222           0.79         0.21
223           0.06         0.94
224           0.51         0.49
225           0.07         0.93
226           0.49         0.51
227           0.13         0.87
228           0.94         0.06
229           0.38         0.62
230           0.50         0.50
231           0.92         0.08
232           0.84         0.16
233           0.78         0.22
234           0.06         0.94
235           0.04         0.96
236           0.65         0.35
237           0.04         0.96
238           0.49         0.51
239           0.06         0.94
240           0.46         0.54
241           0.11         0.89
242           0.93         0.07
243           0.33         0.67
244           0.56         0.44
245           0.90         0.10
246           0.83         0.17
247           0.97         0.03
248           0.07         0.93
249           0.04         0.96
250           0.47         0.53
251           0.10         0.90
252           0.48         0.52
253           0.06         0.94
254           0.43         0.57
255           0.07         0.93
256           0.94         0.06
257           0.19         0.81
258           0.39         0.61
259           0.93         0.07
260           0.81         0.19
261           0.92         0.08
262           0.09         0.91
263           0.01         0.99
264           0.43         0.57
265           0.00         1.00
266           0.47         0.53
267           0.99         0.01
268           0.99         0.01
269           0.99         0.01
270           0.98         0.02
271           0.92         0.08
272           0.77         0.23
273           0.67         0.33
274           0.50         0.50
275           0.17         0.83
276           0.16         0.84
277           0.06         0.94
278           0.07         0.93
279           0.02         0.98
280           0.61         0.39

Column

Chart B

# A tibble: 15 × 3
   Material                        Total Waste Generate…¹ Total Waste Recycled…²
   <chr>                                            <dbl>                  <dbl>
 1 Overall                                      131824000               75119000
 2 Paper/Cardboard                               23530000               11504000
 3 Ferrous Metals                                22414000               20472000
 4 Construction & Demolition                     22245000               21970000
 5 Plastics                                      15797000                1280000
 6 Food                                          13681000                1836000
 7 Wood/Timber                                    6608000                4440000
 8 Horticultural                                  5521000                3197000
 9 Others (stones, ceramic, rubbe…                5426000                 197000
10 Used Slag                                      5003000                4786000
11 Textile/Leather                                2854000                 199000
12 Non-Ferrous Metals                             2094000                1865000
13 Glass                                          1413000                 236000
14 Used slag                                      1366000                1347000
15 Scrap Tyres                                     502000                 431000
# ℹ abbreviated names: ¹​`Total Waste Generated (tonnes)`,
#   ²​`Total Waste Recycled (tonnes)`
# A tibble: 15 × 3
   waste_type                         total_waste_generated total_waste_recycled
   <chr>                                              <dbl>                <dbl>
 1 Overall                                        131824000             75119000
 2 Paper/Cardboard                                 23530000             11504000
 3 Ferrous Metals                                  22414000             20472000
 4 Construction & Demolition                       22245000             21970000
 5 Plastics                                        15797000              1280000
 6 Food                                            13681000              1836000
 7 Wood/Timber                                      6608000              4440000
 8 Horticultural                                    5521000              3197000
 9 Others (stones, ceramic, rubber, …               5426000               197000
10 Used Slag                                        5003000              4786000
11 Textile/Leather                                  2854000               199000
12 Non-Ferrous Metals                               2094000              1865000
13 Glass                                            1413000               236000
14 Used slag                                        1366000              1347000
15 Scrap Tyres                                       502000               431000

Chart C

Chart D

                 waste_type total_waste_generated_tonne
1 Construction & Demolition                     1624000
2 Construction & Demolition                     1440000
3 Construction & Demolition                      825000
4 Construction & Demolition                     1013000
5 Construction & Demolition                     1424000
6 Construction & Demolition                     1595000
  total_waste_recycled_tonne year total_waste_not_recycled_tonne recycling_rate
1                    1618000 2018                              6           1.00
2                    1434000 2019                              6           1.00
3                     822000 2020                              3           1.00
4                    1011000 2021                              2           1.00
5                    1419000 2022                              5           1.00
6                    1586000 2016                              9           0.99
  wasting_rate energy_saved crude_oil_saved
1         0.00        34644           96.00
2         0.00          252            0.72
3         0.00         1926            5.40
4         0.00        28000           80.00
5         0.00        20500           55.00
6         0.01         3600            9.90

======================================================================= ### Chart E

#```{r} #scatter plot graph fig <- plot_ly( data = total_data, x = ~year, y = ~energy_saved, size = ~total_waste_generate_tonne, color = ~material, sizes = c(10, 60), type = “scatter”, mode = “markers” )

fig

Energy saved per year

annual_energy_savings <- total_data %>% group_by(year) %>% summarize(energy_saved = sum(energy_saved))

Convert total_energy_saved to GWh

annual_energy_savings\(total_energy_saved <- round(annual_energy_savings\)energy_saved / 1000000, 2)

Display the result

tail(annual_energy_savings) ```